package com.zhonghui.modlules.user.eshopMapper;


import com.zhonghui.common.eshopMapper.CoreMapper;
import com.zhonghui.modlules.user.eshopDomain.UserExtract;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

@Repository
public interface UserExtractMapper  extends CoreMapper<UserExtract> {

    @Select({"select IFNULL(sum(extract_price),0) from user_extract where status=1 and uid=#{uid}"})
    double sumPrice(@Param("uid") Long uid);
}
